-
Re: Using DISTINCT function
6 · -
Re: Backup
The only way to back-up a dashboard is to manually save it as a PDF. However... When creating the back-ups of the sheets and reports, the data that drives the dashboard for that particular point in t…5 · -
SUCCESSORS Testing
I have seen in the past quite a few people asking how we can leverage predecessors for alerts so that when (for example) the preceding task is complete, a notification goes out automatically to the o…7 · -
Re: Can you use 2 match criterias in an index/match formula?
It is possible using an INDEX/COLLECT. =INDEX(COLLECT({range to pull from}, {first criteria range}, first criteria, {second criteria range}, second criteria), 1)16 · -
Using a nested IF to determine a range
Here's a little tid-bit I just figured out today... You can use a nested IF statement to output ranges/cross sheet references that are to be evaluated. The particular use case that led to this was an…6 ·